It won't return to your sideboard until the game ends
Because it also can't be blocked, you can combine it with effects that trigger when you deal combat damage without worry
Context is Key The question for how good Afterlife will be comes down to what the format looks like

Allies at Last Angelic Observer Argivian Phalanx Assert Authority Banish to Another Universe Banquet Guests Bartz and Boko Blinkmoth Infusion Brine Giant Broodstar Chiss-Goria, Forge Tyrant Chromescale Drake Claws Out Demonic Junker Don & Raph, Hard Science Dross Golem Emry, Lurker of the Loch Ethersworn Sphinx Frogmite Frogmyr Enforcer Furnace Dragon Furnace Hellkite Gate Colossus Gearseeker Serpent Goldwardens' Gambit Hellspur Brute Icebreaker Kraken Imskir Iron-Eater Into Thin Air Junk Winder Krang, Master Mind Lens Flare Leonardo, Worldly Warrior Memory Guardian Millicent, Restless Revenant Mycosynth Golem Myr Enforcer Nahiri, Forged in Fury Omniclown Colossus Oxidda Finisher Oxidda Golem Panther Robot Pearl-Ear, Imperial Advisor Plated Onslaught Polliwallop Quicksilver Behemoth Qumulox Razor Golem Reality Heist Rebel Salvo Refurbished Familiar Riders of the Mark Saheeli, the Gifted Salt Road Packbeast Sami, Wildcat Captain Sapling Nursery Scale of Chiss-Goria Scales of Shale Sky-Blessed Samurai Slag Strider Sojourner's Companion Somber Hoverguard Spire Golem Steelfin Whale Tangle Golem Tezzeret, Master of the Bridge The Circle of Loyalty The Dalek Emperor Thought Monitor Thoughtcast Thrumming Hivepool Tomik, Wielder of Law

This is what split second says: As long as this spell is on the stack, players can't cast spells or activate abilities that aren't mana abilities. Basically, the card with the split second ability will always resolve first
The Hosts player will eventually know this and target you down first